
<!DOCTYPE html>
<html lang="en" class="loading">
<head>
    <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
    <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <title>Excel - fubaisen</title>
    <meta name="apple-mobile-web-app-capable" content="yes" />
    <meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
    <meta name="google" content="notranslate" />
    <meta name="keywords" content="Fechin,"> 
    <meta name="description" content="一、分 析 数 据  ————（分析）掌握透视表-切片器-透视图，分析数据一目了然
1.透视表

2.切片器


3.数据透视图
二、多条件求和  ——（统计）利用函数实现多条件求和，维度再多也不用,"> 
    <meta name="author" content="John Doe"> 
    <link rel="alternative" href="atom.xml" title="fubaisen" type="application/atom+xml"> 
    <link rel="icon" href="/img/favicon.png"> 
    
    
    
    <meta name="twitter:card" content="summary"/>
    <meta name="twitter:title" content="Excel - fubaisen"/>
    <meta name="twitter:description" content="一、分 析 数 据  ————（分析）掌握透视表-切片器-透视图，分析数据一目了然
1.透视表

2.切片器


3.数据透视图
二、多条件求和  ——（统计）利用函数实现多条件求和，维度再多也不用,"/>
    
    
    
    
    <meta property="og:site_name" content="fubaisen"/>
    <meta property="og:type" content="object"/>
    <meta property="og:title" content="Excel - fubaisen"/>
    <meta property="og:description" content="一、分 析 数 据  ————（分析）掌握透视表-切片器-透视图，分析数据一目了然
1.透视表

2.切片器


3.数据透视图
二、多条件求和  ——（统计）利用函数实现多条件求和，维度再多也不用,"/>
    
<link rel="stylesheet" href="/css/diaspora.css">

    <script>window.searchDbPath = "/search.xml";</script>
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Source+Code+Pro&display=swap" rel="stylesheet">
<meta name="generator" content="Hexo 6.3.0"></head>

<body class="loading">
    <span id="config-title" style="display:none">fubaisen</span>
    <div id="loader"></div>
    <div id="single">
    <div id="top" style="display: block;">
    <div class="bar" style="width: 0;"></div>
    <a class="iconfont icon-home image-icon" href="javascript:;" data-url="http://fubaisen.github.io"></a>
    <div title="播放/暂停" class="iconfont icon-play"></div>
    <h3 class="subtitle">Excel</h3>
    <div class="social">
        <div>
            <div class="share">
                <a title="获取二维码" class="iconfont icon-scan" href="javascript:;"></a>
            </div>
            <div id="qr"></div>
        </div>
    </div>
    <div class="scrollbar"></div>
</div>

    <div class="section">
        <div class="article">
    <div class='main'>
        <h1 class="title">Excel</h1>
        <div class="stuff">
            <span>一月 25, 2022</span>
            
  <ul class="post-tags-list" itemprop="keywords"><li class="post-tags-list-item"><a class="post-tags-list-link" href="/tags/%E8%BD%AF%E4%BB%B6/" rel="tag">软件</a></li></ul>


        </div>
        <div class="content markdown">
            <h2 id="一、分-析-数-据-————（分析）"><a href="#一、分-析-数-据-————（分析）" class="headerlink" title="一、分 析 数 据  ————（分析）"></a>一、分 析 数 据  ————（分析）<img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/hn4qxjn8qu68cxbk.gif" alt="img"></h2><p>掌握透视表-切片器-透视图，分析数据一目了然</p>
<h3 id="1-透视表"><a href="#1-透视表" class="headerlink" title="1.透视表"></a>1.透视表</h3><p><img src="https://s2.loli.net/2022/01/20/KbHyoI1BWjMntlp.png" alt="image-20220120220145131"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/sbjqlo4vdz8342tf.gif" alt="img"></p>
<h3 id="2-切片器"><a href="#2-切片器" class="headerlink" title="2.切片器"></a>2.切片器</h3><p><img src="https://s2.loli.net/2022/01/20/AfdcqbBGZKwSJkm.png" alt="image-20220120220244788"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/pqgkpwlmmj0cw4lj.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/20-2.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/j8kgt8dv11kac08n.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/tv69sn09w9nblrak.png" alt="img"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/fusgqvxvn45b6tmw.png" alt="img"></p>
<h3 id="3-数据透视图"><a href="#3-数据透视图" class="headerlink" title="3.数据透视图"></a>3.数据透视图<img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/q4r3vpw0wi98ji32.png" alt="img"></h3><p><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/5wzjbj4bhkve4csz.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/9i42f511x9uddl5o.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2020-12-07/njzt5mph1a4phpch.png" alt="img"></p>
<h2 id="二、多条件求和-——（统计）"><a href="#二、多条件求和-——（统计）" class="headerlink" title="二、多条件求和  ——（统计）"></a>二、多条件求和  ——（统计）<img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/36olksj54ws9qe9f.gif" alt="img"></h2><p>利用函数实现多条件求和，维度再多也不用愁</p>
<h3 id="1-SUM"><a href="#1-SUM" class="headerlink" title="1.SUM"></a>1.SUM<img src="https://s2.loli.net/2022/01/20/vXfUx1HZ4DcYJp5.png" alt="image-20220120214947106"></h3><p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/531i3bxygn6ov8nc.gif" alt="img"></p>
<h3 id="2-SUMIF"><a href="#2-SUMIF" class="headerlink" title="2.SUMIF"></a>2.SUMIF</h3><p><img src="https://s2.loli.net/2022/01/20/XbRt5ANDuTCjELz.png" alt="image-20220120215257717"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/0s8sw43grdvv1buy.gif" alt="image-20220120215204061"></p>
<h3 id="3-SUMIFS"><a href="#3-SUMIFS" class="headerlink" title="3.SUMIFS"></a>3.SUMIFS</h3><p><img src="https://s2.loli.net/2022/01/20/L3g5iJkqTsoBYMm.png" alt="image-20220120215737014"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/vw6cougjpjb301dc.gif" alt="SUMIFS"></p>
<h2 id="三、数据查询系统——（查找）"><a href="#三、数据查询系统——（查找）" class="headerlink" title="三、数据查询系统——（查找）"></a>三、数据查询系统——（查找）<img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/wj4ogxs1gizwco48.gif" alt="img"></h2><p>通过VLOOKUP、数据验证、多表查询，构建了一个轻型数据查询系统</p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/ptw70em59c62fj2m.png" alt="img"></p>
<h3 id="1-VLOOKUP"><a href="#1-VLOOKUP" class="headerlink" title="1.VLOOKUP"></a>1.VLOOKUP</h3><p><img src="https://s2.loli.net/2022/01/20/5kQXq9ewd7OUKFM.png" alt="image-20220120230345471.png"></p>
<h6 id="01-图形键入"><a href="#01-图形键入" class="headerlink" title="01.图形键入"></a>01.图形键入</h6><blockquote>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/vhsnthl7j65w1m1q.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/4ys3ptwc6ckbl4lv.png" alt="img"><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/jw4d38y9k48fpof7.png" alt="img"><img src="https://s2.loli.net/2022/01/20/BcSJZDsG1Rd9Q5t.png" alt="image-20220120221856362.png"></p>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/r34usfjzydf19g4x.gif" alt="img"></p>
</blockquote>
<p><img src="https://s2.loli.net/2022/01/20/lZoPHpsg7hQVnf2.png" alt="image-20220120222455467.png"></p>
<p><img src="https://s2.loli.net/2022/01/20/nmqYfjk97aN4J8O.png" alt="image-20220120224717938.png"></p>
<h6 id="02-公式键入："><a href="#02-公式键入：" class="headerlink" title="02.公式键入："></a>02.公式键入：</h6><blockquote>
<p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/88ykvjh6rzte6ptd.gif" alt="img"></p>
</blockquote>
<h3 id="2-数据验证"><a href="#2-数据验证" class="headerlink" title="2.数据验证"></a>2.数据验证</h3><p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/o1syb0rqbiladyjr.png" alt="img"></p>
<h6 id="01-将-“吴儿”-位置-变成下拉菜单状态"><a href="#01-将-“吴儿”-位置-变成下拉菜单状态" class="headerlink" title="01.将 “吴儿” 位置 变成下拉菜单状态"></a>01.将 “吴儿” 位置 变成下拉菜单状态</h6><p><img src="https://cdn.naixuejiaoyu.com/study/2021-11-06/66gbrrm46q55rwdu.png" alt="img"></p>
<h6 id="02-将-“吴儿”-改成-B3-名称所在位置"><a href="#02-将-“吴儿”-改成-B3-名称所在位置" class="headerlink" title="02.将  “吴儿” 改成  B3( 名称所在位置)"></a>02.将  “吴儿” 改成  B3( 名称所在位置)</h6><p><img src="https://s2.loli.net/2022/01/20/iX9AflWzPcCeuI4.png" alt="image-20220120231127098.png"></p>

            <!--[if lt IE 9]><script>document.createElement('audio');</script><![endif]-->
            <audio id="audio" loop="1" preload="auto" controls="controls" data-autoplay="false">
                <source type="audio/mpeg" src="">
            </audio>
            
                <ul id="audio-list" style="display:none">
                    
                        
                            <li title="0" data-url="http://link.hhtjim.com/163/425570952.mp3"></li>
                        
                    
                        
                            <li title="1" data-url="http://link.hhtjim.com/163/425570952.mp3"></li>
                        
                    
                </ul>
            
        </div>
        
        
    <div id="gitalk-container" class="comment link"
		data-enable="false"
        data-ae="false"
        data-ci=""
        data-cs=""
        data-r=""
        data-o=""
        data-a=""
        data-d="false"
    >查看评论</div>


    </div>
    
</div>


    </div>
</div>
</body>


<script src="//lib.baomitu.com/jquery/1.8.3/jquery.min.js"></script>
<script src="/js/plugin.js"></script>
<script src="/js/typed.js"></script>
<script src="/js/diaspora.js"></script>


<link rel="stylesheet" href="/photoswipe/photoswipe.css">
<link rel="stylesheet" href="/photoswipe/default-skin/default-skin.css">


<script src="/photoswipe/photoswipe.min.js"></script>
<script src="/photoswipe/photoswipe-ui-default.min.js"></script>


<!-- Root element of PhotoSwipe. Must have class pswp. -->
<div class="pswp" tabindex="-1" role="dialog" aria-hidden="true">
    <!-- Background of PhotoSwipe. 
         It's a separate element as animating opacity is faster than rgba(). -->
    <div class="pswp__bg"></div>
    <!-- Slides wrapper with overflow:hidden. -->
    <div class="pswp__scroll-wrap">
        <!-- Container that holds slides. 
            PhotoSwipe keeps only 3 of them in the DOM to save memory.
            Don't modify these 3 pswp__item elements, data is added later on. -->
        <div class="pswp__container">
            <div class="pswp__item"></div>
            <div class="pswp__item"></div>
            <div class="pswp__item"></div>
        </div>
        <!-- Default (PhotoSwipeUI_Default) interface on top of sliding area. Can be changed. -->
        <div class="pswp__ui pswp__ui--hidden">
            <div class="pswp__top-bar">
                <!--  Controls are self-explanatory. Order can be changed. -->
                <div class="pswp__counter"></div>
                <button class="pswp__button pswp__button--close" title="Close (Esc)"></button>
                <button class="pswp__button pswp__button--share" title="Share"></button>
                <button class="pswp__button pswp__button--fs" title="Toggle fullscreen"></button>
                <button class="pswp__button pswp__button--zoom" title="Zoom in/out"></button>
                <!-- Preloader demo http://codepen.io/dimsemenov/pen/yyBWoR -->
                <!-- element will get class pswp__preloader--active when preloader is running -->
                <div class="pswp__preloader">
                    <div class="pswp__preloader__icn">
                      <div class="pswp__preloader__cut">
                        <div class="pswp__preloader__donut"></div>
                      </div>
                    </div>
                </div>
            </div>
            <div class="pswp__share-modal pswp__share-modal--hidden pswp__single-tap">
                <div class="pswp__share-tooltip"></div> 
            </div>
            <button class="pswp__button pswp__button--arrow--left" title="Previous (arrow left)">
            </button>
            <button class="pswp__button pswp__button--arrow--right" title="Next (arrow right)">
            </button>
            <div class="pswp__caption">
                <div class="pswp__caption__center"></div>
            </div>
        </div>
    </div>
</div>






</html>
